Desired file structures

This section outlines the file format requirements for importing data into Axiom Capital Tracking.

To date, Kaufman Hall has had 100% success in communicating with all of our clients’ systems. We vow to never be the weak link in any communications issues. Because of this commitment, we have developed our download procedures to work with multiple file formats. While we would prefer files in a certain format, we will work with whatever you can supply.

Delimited files

Delimited files are acceptable as long as text information is wrapped in quotations. Row 1 may include heading labels. We recommend using a Pipe (|) delimiter instead of a comma, if possible.

Excel files

Excel files are also acceptable. Row1 must be blank or include heading labels.

Remember that these file specifications are those of an “ideal” file. We can work with file structures that are significantly different than the ideal. However, if this is necessary, processing time may be somewhat slower and the time and effort expended in developing and configuring the interface may be more extensive.

NOTE: With the download file, please send tie-out reports for the periods included in the download file. This will allow us to easily verify the accuracy of the download process. Please send related financial statements for ALL download files sent.